This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
RE: Explanation of DECS, LEI and LSDO ~Hal Dwoboosilygon 2.Oct.03 01:28 PM a Web browser General 6.0.1 CF3All Platforms
Apologies as I have posted this question twice a few discussions up. Reason was because the screen did nothing when I saved. Anyway...
You have explained this brilliantly - thanks!
Here's my business problem. Customer information is held on a SQL database. This data is updated via the web by customers who make orders (its an e-business).
However, at the customer service center we use notes. Documents are refreshed once a day and these are opened if a customer calls in. (You can see there may be some inconsistency between data here).
The problem is to have frequent refreshes or even use real time data. Data may be updated at either end - notes or SQL db.
My idea is this...
(write the front end in ASP!) I wonder, rather than having data in two places - notes and SQL, why not just use domino as the front end and access the SQL db through a browser using Domino? This is a route I am going down so am yet to see if this will work.
I am going to use Domino to access the stored procedures in the SQL database so will be able to read, update, create and delete in the SQL DB in real time. I have played with LCLSX so think this will work.
I thought why bother having notes documents.
Can you see any problem to doing this?
Now the next question refers to the technologies. It appears to me that LCLSX will do what DECS and LEI can do - only it requires programming but nevermind.
To get DECs I presume I have to install server to get at the DECS database.
DCR is something I've tried but couldn't get to connect despite having secured a connection using LSX.
One final question. I am not even sure that I have been using LSX!
My inialise script is using. I'm beginning to think that is ODBC connectivity.
Dim session As New NotesSession
Dim db As NotesDatabase
Dim doc As NotesDocument
Dim con As New ODBCConnection
Dim rs As New ODBCResultSet
Dim query As New ODBCQuery
Dim sql As String
Set db = Session.CurrentDatabase
Call con.ConnectTo("Customerdb")
If con.IsConnected Then
Messagebox ("Connected")
End If
con.disconnect
I think the Help document 'Working with the LSX' is the only documentation there is.
Return to top
. . . . RE: Explanation of DECS, LEI and LS... (~Hal Dwoboosily... 2.Oct.03) 
Print this page
